/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.mes.action.certificate;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.talent.util.data.FlowUtil;
import cn.javaxc.model.page.*;
import cn.javaxc.mes.mapper.certificate.CertificateMapper;
public class CertificateAction extends BaseAction
{
    @Autowired(required=false)
	private CertificateMapper mapper;
    
    public String multipleLike(Map sqlMap,VUEPage page){
        return FrameHelper.multipleLike(sqlMap,new String[]{
            "and kp.part_name like :part_name"
            ,"and kp.part_model like :part_model"
            ,"and kp.part_norm like :part_norm"
            ,"and cm.client_name like :client_name"
        },(List)pagination.getMap().get("key_part_list"),page);
    }
    
    /**
    证书统计图
    */
    
    public Map certificateStatistics() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_setup=mapper.s_setup(params);
        result.put("s_setup", s_setup);
        
        
        SQLList<SQLMap> s_type=mapper.s_type(params);
        result.put("s_type", s_type);
        
        return result;
    }
    /**
    */
    
    public Object s_cer() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_cer=mapper.s_cer(params,pagination);
        s_cer.setPagedListInfo(pagination);
        result.put("s_cer", s_cer);
        
        return s_cer;
    }
    /**
    饼状统计图
    */
    
    public Map certificatePancake() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> s_c=mapper.s_c(params);
        result.put("s_c", s_c);
        
        return result;
    }
    /**
    增加证书
    */
    
    public Map certificateIncrease() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_setup=mapper.s_setup(params);
        result.put("s_setup", s_setup);
        
        
        SQLList<SQLMap> s_type=mapper.s_type(params);
        result.put("s_type", s_type);
        
        
        SQLList<SQLMap> t_dept_name=mapper.t_dept_name(params);
        SQLMap t_dept_name_emt=t_dept_name.getExistfirst();
        result.put("t_dept_name", t_dept_name_emt);
        
        return result;
    }
    /**
    */
    
    public Object message() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> message=mapper.message(params,pagination);
        message.setPagedListInfo(pagination);
        result.put("message", message);
        
        return message;
    }
    /**
    选择文件
    */
    
    public Map selectFilely() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        params.def("CMID9",98);
        Object CMID9 =mapper.CMID9(params);
        result.put("CMID9", CMID9);
        
        
        params.def("CMID9",-1);
        SQLList<SQLMap> s_folder=mapper.s_folder(params);
        result.put("s_folder", s_folder);
        
        
        SQLList<SQLMap> s_files=mapper.s_files(params,pagination);
        s_files.setPagedListInfo(pagination);
        result.put("s_files", s_files);
        
        
        params.def("CMID9",-1);
        SQLList<SQLMap> s_tree_menu=mapper.s_tree_menu(params);
        result.put("s_tree_menu", s_tree_menu);
        
        return result;
    }
    /**
    证书详情
    */
    
    public Map certificateDetails() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_cer=mapper.t_cer(params);
        SQLMap t_cer_emt=t_cer.getExistfirst();
        result.put("t_cer", t_cer_emt);
        
        return result;
    }
    /**
    修改证书
    */
    
    public Map modeCertificate() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_setup=mapper.s_setup(params);
        result.put("s_setup", s_setup);
        
        
        SQLList<SQLMap> s_setup_type=mapper.s_setup_type(params);
        result.put("s_setup_type", s_setup_type);
        
        
        SQLList<SQLMap> t_cer=mapper.t_cer(params);
        SQLMap t_cer_emt=t_cer.getExistfirst();
        result.put("t_cer", t_cer_emt);
        
        return result;
    }
    /**
    变更信息
    */
    
    public Map changeInformation() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_cer=mapper.s_cer(params,pagination);
        s_cer.setPagedListInfo(pagination);
        result.put("s_cer", s_cer);
        
        return result;
    }
    /**
    增加变更
    */
    
    public Map addChange() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_setup=mapper.s_setup(params);
        result.put("s_setup", s_setup);
        
        
        SQLList<SQLMap> s_type=mapper.s_type(params);
        result.put("s_type", s_type);
        
        return result;
    }
    /**
    变更详情
    */
    
    public Map changeDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_change=mapper.t_change(params);
        SQLMap t_change_emt=t_change.getExistfirst();
        result.put("t_change", t_change_emt);
        
        return result;
    }
    /**
    适用产品
    */
    
    public Map productsUsed() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> p_product=mapper.p_product(params,pagination);
        p_product.setPagedListInfo(pagination);
        result.put("p_product", p_product);
        
        return result;
    }
    /**
    增加产品
    */
    
    public Map addProduct() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_index=mapper.s_index(params);
        result.put("s_index", s_index);
        
        return result;
    }
    /**
    修改产品
    */
    
    public Map modifyProduct() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        return result;
    }
    /**
    关联型号管理
    */
    
    public Map correlationModel1() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_product_model=mapper.s_product_model(params,pagination);
        s_product_model.setPagedListInfo(pagination);
        result.put("s_product_model", s_product_model);
        
        return result;
    }
    /**
    关联规格
    */
    
    public Map correlationSpecifica() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    增加关联型号
    */
    
    public Map correlationModelAdd() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    关联型号
    */
    
    public Map correlationModel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    关联规格
    */
    
    public Map correlationSpecificaS() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    关联关键件
    */
    
    public Map correlationSpecificaKey() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    */
    
    public Object s_model() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return s_model;
    }
    /**
    增加型号
    */
    
    public Map addModel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_index=mapper.s_index(params);
        result.put("s_index", s_index);
        
        return result;
    }
    /**
    修改型号
    */
    
    public Map modifyModel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_model=mapper.t_model(params);
        SQLMap t_model_emt=t_model.getExistfirst();
        result.put("t_model", t_model_emt);
        
        return result;
    }
    /**
    修改规格
    */
    
    public Map modifySpecificationsModel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    关联规格
    */
    
    public Map correlationSpecificationModel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    增加关联规格
    */
    
    public Map addCorrelationSpecification() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    关键件关系
    */
    
    public Map keyComponent() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    增加关键件
    */
    
    public Map addingKeyModel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    适用规格
    */
    
    public Map applicableNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    增加规格
    */
    
    public Map addNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_index=mapper.s_index(params);
        result.put("s_index", s_index);
        
        
        
        return result;
    }
    /**
    修改规格
    */
    
    public Map modiffyNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_norm=mapper.t_norm(params);
        SQLMap t_norm_emt=t_norm.getExistfirst();
        result.put("t_norm", t_norm_emt);
        
        return result;
    }
    /**
    关联型号
    */
    
    public Map correlationModelNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    增加型号
    */
    
    public Map addModelNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    关键增加型号
    */
    
    public Map addCorrelationModelNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    关联关键件
    */
    
    public Map keyComponentNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    增加关键件
    */
    
    public Map addKeyNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    关联增加关键件
    */
    
    public Map addKeyComponentNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    所属产品
    */
    
    public Map productsBelongingCertificate() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_info=mapper.s_info(params);
        result.put("s_info", s_info);
        
        return result;
    }
    /**
    关键件
    */
    
    public Map critical() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    增加关键件
    */
    
    public Map addCritical() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_index=mapper.s_index(params);
        result.put("s_index", s_index);
        
        return result;
    }
    /**
    选择关键件
    */
    
    public Map choiceCritical() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params,pagination);
        s_product.setPagedListInfo(pagination);
        result.put("s_product", s_product);
        
        
        
        
        
        return result;
    }
    /**
    关键件关系
    */
    
    public Map criticalRelations() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> steps=mapper.steps(params);
        result.put("steps", steps);
        
        
        SQLList<SQLMap> skips=mapper.skips(params);
        result.put("skips", skips);
        
        
        FlowUtil.buildFlow(steps,null);
        
        
        
        
        
        return result;
    }
    /**
    单个关系
    */
    
    public Map singleRelationship() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> steps=mapper.steps(params);
        result.put("steps", steps);
        
        
        SQLList<SQLMap> skips=mapper.skips(params);
        result.put("skips", skips);
        
        
        Object part_name =mapper.part_name(params);
        result.put("part_name", part_name);
        
        return result;
    }
    /**
    */
    
    public Object s_part() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> l_part=mapper.l_part(params);
        result.put("l_part", l_part);
        
        return l_part;
    }
    /**
    适用用标准
    */
    
    public Map applicableStandard() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_use=mapper.s_use(params);
        result.put("s_use", s_use);
        
        return result;
    }
    /**
    上传使用标准
    */
    
    public Map uploadStandard() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_index=mapper.s_index(params);
        result.put("s_index", s_index);
        
        return result;
    }
    /**
    证书关系
    */
    
    public Map certificateRelation() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    增加证书关系
    */
    
    public Map addCertificateRelation() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> l_product=mapper.l_product(params);
        result.put("l_product", l_product);
        
        
        SQLList<SQLMap> l_model=mapper.l_model(params);
        result.put("l_model", l_model);
        
        
        SQLList<SQLMap> l_norm=mapper.l_norm(params);
        result.put("l_norm", l_norm);
        
        return result;
    }
    /**
    增加产品
    */
    
    public Map increaseProduct() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params,pagination);
        s_product.setPagedListInfo(pagination);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    关联型号
    */
    
    public Map correlationModelPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    增加型号
    */
    
    public Map addModelPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    关联规格
    */
    
    public Map correlationNormPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    增加规格
    */
    
    public Map addNormPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    关键件关系
    */
    
    public Map keyRelationsPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    增加关键件
    */
    
    public Map addKeyRelationsPro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    实验报告
    */
    
    public Map experimentReport() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_report=mapper.s_report(params);
        result.put("s_report", s_report);
        
        return result;
    }
    /**
    修改证书
    */
    
    public Map upExperimentReport() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_exe=mapper.t_exe(params);
        SQLMap t_exe_emt=t_exe.getExistfirst();
        result.put("t_exe", t_exe_emt);
        
        return result;
    }
    /**
    搜索证书
    */
    
    public Map searchCertificate() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> cer_product=mapper.cer_product(params);
        result.put("cer_product", cer_product);
        
        
        SQLList<SQLMap> s_index=new SQLList();
        result.put("s_index", s_index);
        
        
        SQLList<SQLMap> s_index1=mapper.s_index1(params);
        result.put("s_index1", s_index1);
        
        return result;
    }
    /**
    搜索证书列表
    */
    
    public Map searchCertificateList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.putAll(pagination.getMap());
        SQLList<SQLMap> s_certificate=mapper.s_certificate(params);
        result.put("s_certificate", s_certificate);
        
        return result;
    }
    /**
    关键件查询列表
    */
    
    public Map keySearchList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    搜索产品
    */
    
    public Map searchProduct() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params,pagination);
        s_product.setPagedListInfo(pagination);
        result.put("s_product", s_product);
        
        return result;
    }
    /**
    搜索型号
    */
    
    public Map searchModel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_model=mapper.s_model(params,pagination);
        s_model.setPagedListInfo(pagination);
        result.put("s_model", s_model);
        
        return result;
    }
    /**
    搜索规格
    */
    
    public Map searchNorm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> s_norm=mapper.s_norm(params,pagination);
        s_norm.setPagedListInfo(pagination);
        result.put("s_norm", s_norm);
        
        return result;
    }
    /**
    选择关键件
    */
    
    public Map searchKey() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        result.put("s_search", pagination.getSearchParas());
        
        
        params.def("apply_product_id",getParameter("CMIDproduct_id"));
        Object CMIDproduct_id =mapper.CMIDproduct_id(params);
        result.put("CMIDproduct_id", CMIDproduct_id);
        
        
        params.def("CMIDproduct_id",-1);
        Object product_name =mapper.product_name(params);
        result.put("product_name", product_name);
        
        
        SQLList<SQLMap> s_part=mapper.s_part(params,pagination);
        s_part.setPagedListInfo(pagination);
        result.put("s_part", s_part);
        
        return result;
    }
    /**
    证书类型
    */
    
    public Map certificateType() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> p_type=mapper.p_type(params,pagination);
        p_type.setPagedListInfo(pagination);
        result.put("p_type", p_type);
        
        return result;
    }
    /**
    增加证书类型
    */
    
    public Map addCertificateType() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_setup=mapper.s_setup(params);
        result.put("s_setup", s_setup);
        
        return result;
    }
    /**
    增加证书类型
    */
    
    public Map addCertificateTypes() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_cer=mapper.t_cer(params);
        SQLMap t_cer_emt=t_cer.getExistfirst();
        result.put("t_cer", t_cer_emt);
        
        
        SQLList<SQLMap> s_setup=mapper.s_setup(params);
        result.put("s_setup", s_setup);
        
        return result;
    }
    /**
    认证类型
    */
    
    public Map authenticationType() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_setup=mapper.s_setup(params);
        result.put("s_setup", s_setup);
        
        return result;
    }
    /**
    修改认证类型
    */
    
    public Map upAuthenticationType() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_setup=mapper.t_setup(params);
        SQLMap t_setup_emt=t_setup.getExistfirst();
        result.put("t_setup", t_setup_emt);
        
        return result;
    }
    /**
    */
    
    public Map d_cer() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_cer(params);
        
        return result;
    }
    /**
    增加证书修改
    */
    
    public Map certificateIncreaseSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.def("fileid",null);
        int CMIDcertificate_id = mapper.CMIDcertificate_id(params);
        result.put("CMIDcertificate_id", CMIDcertificate_id);
        
        return result;
    }
    /**
    证书详情修改
    */
    
    public Map certificateDetailsSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        return result;
    }
    /**
    */
    
    public Map down_excel() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_cer_title =buildExcelTitle(CertificateAction.class,"t_cer_title");
        
        
        SQLList<SQLMap> t_cer=mapper.t_cer(params);
        SQLMap t_cer_emt=t_cer.getExistfirst();
        result.put("t_cer", t_cer_emt);
        
        
        SQLList<SQLMap> s_product_title =buildExcelTitle(CertificateAction.class,"s_product_title");
        
        
        SQLList<SQLMap> l_product=mapper.l_product(params);
        result.put("l_product", l_product);
        
        
        SQLList<SQLMap> s_norm_title =buildExcelTitle(CertificateAction.class,"s_norm_title");
        
        
        SQLList<SQLMap> l_norm=mapper.l_norm(params);
        result.put("l_norm", l_norm);
        
        
        SQLList<SQLMap> s_model_title =buildExcelTitle(CertificateAction.class,"s_model_title");
        
        
        SQLList<SQLMap> l_model=mapper.l_model(params);
        result.put("l_model", l_model);
        
        
        SQLList<SQLMap> s_part_title =buildExcelTitle(CertificateAction.class,"s_part_title");
        
        
        SQLList<SQLMap> l_part=mapper.l_part(params);
        result.put("l_part", l_part);
        
        
        SQLList<SQLMap> s_use_title =buildExcelTitle(CertificateAction.class,"s_use_title");
        
        
        SQLList<SQLMap> s_use=mapper.s_use(params);
        result.put("s_use", s_use);
        
        
        TreeTableHelper.exportList(context
        ,CommonUtil.asList(t_cer,l_product,l_norm,l_model,l_part,s_use)
        ,CommonUtil.asList(t_cer_title,s_product_title,s_norm_title,s_model_title,s_part_title,s_use_title)
        ,new String[]{"基本信息","适用产品","适用规格","适用型号","关键件","适用标准"}
        ,"证书"+t_cer_emt.getString("certificate_num")+".xls");
        
        return null;
    }
    /**
    修改证书修改
    */
    
    public Map modeCertificateSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.def("fileid",-1);
        mapper.modeCertificateSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_change() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_change(params);
        
        return result;
    }
    /**
    增加变更修改
    */
    
    public Map addChangeSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.def("fileid",null);
        int CMIDchange_id = mapper.CMIDchange_id(params);
        result.put("CMIDchange_id", CMIDchange_id);
        
        return result;
    }
    /**
    */
    
    public Map d_product() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_product(params);
        
        return result;
    }
    /**
    增加产品修改
    */
    
    public Map addProductSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("apply_product")){
            params=new SQLParam(request,emt.getMap());
            mapper.CMIDproduct_id(params);
        }
        
        
        
        return result;
    }
    /**
    修改产品修改
    */
    
    public Map modifyProductSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.modifyProductSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_batch_product() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.d_batch_product(params);
        }
        
        return result;
    }
    /**
    关联规格修改
    */
    
    public Map correlationSpecificaSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.correlationSpecificaSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    增加关联型号修改
    */
    
    public Map correlationModelAddSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.correlationModelAddSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    */
    
    public Map d_model() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_model(params);
        
        return result;
    }
    /**
    */
    
    public Map d_batch_model() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.d_batch_model(params);
        }
        
        return result;
    }
    /**
    增加型号修改
    */
    
    public Map addModelSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addModelSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    修改型号修改
    */
    
    public Map modifyModelSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.modifyModelSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_re_norm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_re_norm(params);
        
        return result;
    }
    /**
    */
    
    public Map d_batch_norm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.d_batch_norm(params);
        }
        
        return result;
    }
    /**
    关联规格修改
    */
    
    public Map correlationSpecificationModelSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.correlationSpecificationModelSubmit(params);
        }
        
        return result;
    }
    /**
    增加关联规格修改
    */
    
    public Map addCorrelationSpecificationSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addCorrelationSpecificationSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    */
    
    public Map d_part() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_part(params);
        
        return result;
    }
    /**
    */
    
    public Map d_batch_part() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.d_batch_part(params);
        }
        
        return result;
    }
    /**
    增加关键件修改
    */
    
    public Map addingKeyModelSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addingKeyModelSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    */
    
    public Map d_norm() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_norm(params);
        
        return result;
    }
    /**
    增加规格修改
    */
    
    public Map addNormSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("apply_norm")){
            params=new SQLParam(request,emt.getMap());
            mapper.addNormSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    修改规格修改
    */
    
    public Map modiffyNormSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.modiffyNormSubmit(params);
        
        return result;
    }
    /**
    增加型号修改
    */
    
    public Map addModelNormSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addModelNormSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    关键增加型号修改
    */
    
    public Map addCorrelationModelNormSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.b_relation_norm(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.b_relation_part(params);
        }
        
        return result;
    }
    /**
    */
    
    public Map d_re_part() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_re_part(params);
        
        return result;
    }
    /**
    增加关键件修改
    */
    
    public Map addKeyNormSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.b_relation_norm_part(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.b_relation_part(params);
        }
        
        return result;
    }
    /**
    关联增加关键件修改
    */
    
    public Map addKeyComponentNormSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addKeyComponentNormSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    */
    
    public Map u_relation() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.u_relation(params);
        }
        
        return result;
    }
    /**
    增加关键件修改
    */
    
    public Map addCriticalSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addCriticalSubmit(params);
        }
        
        
        
        return result;
    }
    /**
    建立关系修改
    */
    
    public Map establishRelationSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.establishRelationSubmit(params);
        
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.b_part_relation(params);
        }
        
        return result;
    }
    /**
    */
    
    public Map d_use() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_use(params);
        
        return result;
    }
    /**
    上传使用标准修改
    */
    
    public Map uploadStandardSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            params.def("fileid",null);
            mapper.uploadStandardSubmit(params);
        }
        
        return result;
    }
    /**
    增加证书关系修改
    */
    
    public Map addCertificateRelationSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.addCertificateRelationSubmit(params);
        
        return result;
    }
    /**
    增加产品修改
    */
    
    public Map increaseProductSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.increaseProductSubmit(params);
        }
        
        return result;
    }
    /**
    增加型号修改
    */
    
    public Map addModelProSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addModelProSubmit(params);
        }
        
        return result;
    }
    /**
    增加规格修改
    */
    
    public Map addNormProSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addNormProSubmit(params);
        }
        
        return result;
    }
    /**
    增加关键件修改
    */
    
    public Map addKeyRelationsProSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("")){
            params=new SQLParam(request,emt.getMap());
            mapper.addKeyRelationsProSubmit(params);
        }
        
        return result;
    }
    /**
    */
    
    public Map d_files() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_files(params);
        
        return result;
    }
    /**
    增加证书修改
    */
    
    public Map addExperimentReportSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.def("fileid",null);
        int i_report = mapper.i_report(params);
        result.put("i_report", i_report);
        
        return result;
    }
    /**
    修改证书修改
    */
    
    public Map upExperimentReportSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        params.def("fileid",null);
        mapper.upExperimentReportSubmit(params);
        
        return result;
    }
    /**
    搜索证书修改
    */
    
    public Map searchCertificateSubmit()throws Exception {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        super.onSearch();
        pagination.getMap().put("key_part_list",hqlBean.getTableElements("key_part"));
        
        return result;
    }
    /**
    */
    
    public Map d_type() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_type(params);
        
        return result;
    }
    /**
    增加证书类型修改
    */
    
    public Map addCertificateTypeSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int i_type = mapper.i_type(params);
        result.put("i_type", i_type);
        
        return result;
    }
    /**
    增加证书类型修改
    */
    
    public Map addCertificateTypesSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.addCertificateTypesSubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_setup() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_setup(params);
        
        return result;
    }
    /**
    增加认证类型修改
    */
    
    public Map addAuthenticationTypeSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int i_setup = mapper.i_setup(params);
        result.put("i_setup", i_setup);
        
        return result;
    }
    /**
    修改认证类型修改
    */
    
    public Map upAuthenticationTypeSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.upAuthenticationTypeSubmit(params);
        
        return result;
    }
    public Map ajaxAdd(){
        String sql="";
        String pagesql="";
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        if(request.getParameter("cfield_name").contains("certificate_type")){
            SQLList<SQLMap> certificate_type=mapper.certificate_type(params);
            result.put("certificate_type", certificate_type);
        }
        
        return result;
    }
    public Map ajaxMode(){
        String sql="";
        String pagesql="";
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        if(request.getParameter("cfield_name").contains("certificate_type")){
            SQLList<SQLMap> certificate_type=mapper.certificate_type(params);
            result.put("certificate_type", certificate_type);
        }
        
        return result;
    }
    public Map ajaxChange(){
        String sql="";
        String pagesql="";
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        if(request.getParameter("cfield_name").contains("certificate_type")){
            SQLList<SQLMap> certificate_type=mapper.certificate_type(params);
            result.put("certificate_type", certificate_type);
        }
        
        return result;
    }
    public Map ajaxCertificate(){
        String sql="";
        String pagesql="";
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        if(request.getParameter("cfield_name").contains("model_id")){
            SQLList<SQLMap> model_id=mapper.model_id(params);
            result.put("model_id", model_id);
        }
        
        
        if(request.getParameter("cfield_name").contains("norm_id")){
            SQLList<SQLMap> norm_id=mapper.norm_id(params);
            result.put("norm_id", norm_id);
        }
        
        return result;
    }
    public String ajaxComplete(){
        String sql="";
        String pagesql="";
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        if(request.getParameter("cfield_name").equals("s_client_filename")){
            SQLList<SQLMap> s_client_filename=mapper.s_client_filename(params);
            request.setAttribute("s_client_filename", s_client_filename);
        }
        
        
        if(request.getParameter("cfield_name").equals("s_client_subject")){
            SQLList<SQLMap> s_client_subject=mapper.s_client_subject(params);
            request.setAttribute("s_client_subject", s_client_subject);
        }
        
        return AJAXCOMPLETE;
    }
}